UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TMnOYID4yG6QNgsg3C/aHoy8KVpqqqBI3uMciecsNUk='
WHERE
key_id = '13a4e540c0002af6c60b029e20dbd992aff3e887c259ac2af36dca895427f127'
AND (
token = 'TMnOYID4yG6QNgsg3C/aHoy8KVpqqqBI3uMciecsNUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)