UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tXqxYmyksHbhY1QlzYiYu9J78oLXZ1S8HVnvHdOfj7A='
WHERE
key_id = '84b830b2a28f178f4a88d6321aa518dba600899abecca3a366eda5442e1c71b7'
AND (
token = 'tXqxYmyksHbhY1QlzYiYu9J78oLXZ1S8HVnvHdOfj7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)