Update value at a specific time SQLite

How can you update a column data on a specific time of the day(mid night - 00:00:00)

CREATE TRIGGER currentDay
   AFTER UPDATE ON users
   WHEN TIME('now', 'localtime') == 00:00:00
BEGIN
    INSERT INTO users (
        currentDayValue
    )
VALUES
    (
        1000
    ) ;
END;

The above is a Trigger for the SQLite, but WHEN TIME('now', 'localtime') == 00:00:00 does not work. any help would be appreciated