UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXgaa9AsgKYwtpJJNe3at5w96BAreVL0Hji0TnN9hN4='
WHERE
key_id = '4171e697da3ad66ca583c22d141e2fa5c031e87bf0006eb19ed42ec0a5fcddcf'
AND (
token = 'pXgaa9AsgKYwtpJJNe3at5w96BAreVL0Hji0TnN9hN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)