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