UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jNnJF8HD3OtWQBdC9OXgNM6VLPdVoY7npmYiavDx2UY='
WHERE
key_id = '1d6fca3ebafe75c54320ec58caceb9c77b85eedb36aec082d202bc7280c2d18a'
AND (
token = 'jNnJF8HD3OtWQBdC9OXgNM6VLPdVoY7npmYiavDx2UY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)