SELECT * FROM table1 WHERE hour(time) > 5;

SELECT * FROM table1 WHERE hour(convert_tz(time, @@session.time_zone, 'America/New_York')) > 5;