UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9TFOXuD32xE1hyR7OwkuMpOx6sd/Phlh/7C/gzu64I='
WHERE
key_id = '9f07ee952e86fe9785e5ecb39d612e6030a2744377c82f8639b89f1d3f5009fc'
AND (
token = 'p9TFOXuD32xE1hyR7OwkuMpOx6sd/Phlh/7C/gzu64I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)