UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mpchVINLq0rJzkVsO6JGEZXFMsggNhdchNy9Bl1R2e4='
WHERE
key_id = '8a79be54fb3ade69acd4ba0367aa2849c29de861ead199469e36202d44d865b1'
AND (
token = 'mpchVINLq0rJzkVsO6JGEZXFMsggNhdchNy9Bl1R2e4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)