UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9s0RmpALdj8VhA2Mtd6N4G3NE2u2FBG4zO3tS5HSqso='
WHERE
key_id = '9030e8c8d033f3f0616ceaf64f2540f99a081bb50f6dee0ed4be3b7837c0d3c8'
AND (
token = '9s0RmpALdj8VhA2Mtd6N4G3NE2u2FBG4zO3tS5HSqso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)