Time Based Sqlite query

Assume a Sqlite3 table with two columns Date(Unix timestamp) and Count. Count is a real number, if that matters.

I need to find days(local time) with a total count of 1 but only where that 1 occurs between 00:00 and 08:00(local time). Then I need to change that 1 to 0.