UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUmabP2ha1/sp7PRH5j38exzaZyGUhm5jtmT7k8d0Z4='
WHERE
key_id = '1b1659e0828483f63ae6ca23fd19f5c171cf74bb0f231028b75a84e1a280fd09'
AND (
token = 'XUmabP2ha1/sp7PRH5j38exzaZyGUhm5jtmT7k8d0Z4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)