UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DzDWf5yhWMM+ZAYESM9ZXl30SrxRrNrKjYxAoITXLwI='
WHERE
key_id = '3d8fce9abc759928e427b043caea6924794e5c51545c46bc018315fe0f647bd3'
AND (
token = 'DzDWf5yhWMM+ZAYESM9ZXl30SrxRrNrKjYxAoITXLwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)