UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IOzHOsE1CttmaF0Oro5FFTMs7jX54J9dYACS5RGKcFU='
WHERE
key_id = '51333c1db48379b456b2e170c17385ab7b083fcc070e6e2545284246ed01e106'
AND (
token = 'IOzHOsE1CttmaF0Oro5FFTMs7jX54J9dYACS5RGKcFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)