UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bkO7lFzlqA3CKc3u2HdbVGUU7SF2xgsHvxOtZVCb8kQ='
WHERE
key_id = '821fe9a93095956e54690c8de0df698b26a911d9f026f5b065db4a3db27ef641'
AND (
token = 'bkO7lFzlqA3CKc3u2HdbVGUU7SF2xgsHvxOtZVCb8kQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)