UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3SNZEpXxrD01s41y9VzIe8FXOG4cUAdlNJUG7JdOzSM='
WHERE
key_id = '8b5e15e2aeb98b2ac8b8ddac11947570e90af13c230353aaedf44b8680447056'
AND (
token = '3SNZEpXxrD01s41y9VzIe8FXOG4cUAdlNJUG7JdOzSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)