I think this is better as the math on the right-hand side is only done once (I hope) and there's no need to do conversion of the timestamp for each row

WHERE timestamp >= CAST(to_unixtime(DATE_ADD('hour', -1, CURRENT_TIMESTAMP)) * 1000 as BIGINT)