The HOUR([unixtime]) function returns the hour (0-23) in the local time zone, either the current hour, or the hour of the specified unixtime.
HOUR() === the current hour HOUR( unixtime ) === the hour of the unix time