Create a mysql event with condition I currently have a mysql database where I keep data about rented books. When somebody rents a book, I save on the database an expiration date. 

So, I want to create an mysql event to update the book status when it is not returned in time. How can I create this event?

Here's what I'm trying:

CREATE EVENT `EXPIRE` ON SCHEDULE EVERY 1
 HOUR STARTS '2016-07-16 00:00:00.000000' ENDS '2018-07-29 
00:00:00.000000' ON COMPLETION NOT PRESERVE ENABLE DO DO IF 
mtl_rents.dateLimit=CURRENT_DATE THEN
        UPDATE mtl_rents SET mtl_rents.status='Expired'
    END IF


But I'm getting Syntax errors on the IF.
You have double DO at the end of the third line.