UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SMFgH3HLupYf00BLrobDRBDgEcq8SQF2D4TwKsBmYMM='
WHERE
key_id = '4165c86a5ed87a9e65c3d2e28fa1c5c4c8d78a303ce2e971ebb2beb228bb9674'
AND (
token = 'SMFgH3HLupYf00BLrobDRBDgEcq8SQF2D4TwKsBmYMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)