UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sL5wLrRsF7XbW3k1kVN/cpWI6479UnLQG9L2uR+AD6A='
WHERE
key_id = 'c1c455cad8ad406bd3ce22331b60b9df6bf8f88d71f63d9bd204303d5c96fc7e'
AND (
token = 'sL5wLrRsF7XbW3k1kVN/cpWI6479UnLQG9L2uR+AD6A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)