UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hr40GNTF6pR6tjXMhorF7usTcnZ1uaai20ciuMi+9zA='
WHERE
key_id = '88c3f3982619d07b1bb2cee90d16b410c3a32e0c7ce80246c3bdc1eb51296322'
AND (
token = 'Hr40GNTF6pR6tjXMhorF7usTcnZ1uaai20ciuMi+9zA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)