UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZFcZ7vH1248e8BFpYj4fgcAHuI3QbLnifazvr9j7L4='
WHERE
key_id = 'afd6bee3bca3fd66acd23a32c877a4f1d7a901e3e91fe8384b60bbde3bc26533'
AND (
token = 'pZFcZ7vH1248e8BFpYj4fgcAHuI3QbLnifazvr9j7L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)