Unique key constraint in mysql
You could use a simple integer column as your hourly key constraint. The unique hour for each possible time can be determined by

select floor(now()/10000)


which will return something like 

2015090511


for the current date 5.9.2015 at  11.25h