SQL Server - MyCTE query based on 24 hour period (next day)

I have this bit of code:

我有这段代码:

;WITH MyCTE AS
(
    SELECT *,
           ROW_NUMBER() OVER(PARTITION BY CardUser ORDER BY CardTableID) AS NewVariation
    FROM   CardChecker
)
UPDATE MyCTE 
SET    Status = NewVariation
;WITH MyCT