UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbfd2noDkezthimTVXL+eD0BB4hMaQOL3TbMwVhqVgk='
WHERE
key_id = 'e718407bb9e7ecdd13ce7fbd57052966919e8efc4b870518cabc9023cf77ca73'
AND (
token = 'bbfd2noDkezthimTVXL+eD0BB4hMaQOL3TbMwVhqVgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)