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