UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9JPILwxMZwlAYNH4A0cvu4Ofv/7xycdqJDU/JxZf95g='
WHERE
key_id = '9920b080bc02be3e90e3de92a8002636a9682439a24974d1e6649847ef57a44f'
AND (
token = '9JPILwxMZwlAYNH4A0cvu4Ofv/7xycdqJDU/JxZf95g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)