UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V2vekmkqw75rLewNKBA3uh7NWE2gkwtawpAKK+eELRE='
WHERE
key_id = 'beac9b79ab94cb10f73f2fd7092e23ccc1daf41b6ca5cf41b24928050d8ee4b6'
AND (
token = 'V2vekmkqw75rLewNKBA3uh7NWE2gkwtawpAKK+eELRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)