UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OBF5UJUSt8nIRygrgiVpoAodTMv7VPNS8z5PVaagOfY='
WHERE
key_id = '1f9422ac9eec14abf306af97d26479eb7fc974cac2e4fdf61f21ca1fa30d5ad4'
AND (
token = 'OBF5UJUSt8nIRygrgiVpoAodTMv7VPNS8z5PVaagOfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)