UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZLTXKebVAKd2S3GH0nT3nodVzgDPUEC1qs4Ja05DIo='
WHERE
key_id = 'd1dba4abf89e615f49a87bee5fd26f4487297abf6a5ef1d245c3dbe806be7e8b'
AND (
token = 'xZLTXKebVAKd2S3GH0nT3nodVzgDPUEC1qs4Ja05DIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)