UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ncmGONVj5khUrHzyXFlhxBwyV2NEbsWQBYqatSij48='
WHERE
key_id = '1164dea55d57bbb0e725424c21d4fa8f1d439a39e97f98c886c11984a487da37'
AND (
token = '0ncmGONVj5khUrHzyXFlhxBwyV2NEbsWQBYqatSij48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)