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