Mysql事件是好的选项，或者可以使用数据库触发器如果你有较旧版本的mysql。

Mysql events is good option or you can use database triggers if you have older version of mysql.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
http://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/