UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbbujL/SV7uYa5mYOh8e/VDHl7ozDvn3YSYo95iHHS0='
WHERE
key_id = '7e288727a771e81b86ec2fbf7702aac533a9b93c687fc025e660855075f00102'
AND (
token = 'hbbujL/SV7uYa5mYOh8e/VDHl7ozDvn3YSYo95iHHS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)