Mysql-Mysql write process function problems, please help

Write an SQL function to control the status field of a table. when the actual time is later than the time in the datatime field in the table, modify the status field value to 1, which is probably when creating an activity, the database executes the function by hour until the value of the status field is 1 when the condition is met. Thought or rough writing, mysqlsql database

Write an SQL function to control the status field of a table.

When the actual time is later than the time in the datatime field in the table, the value of the status field is changed to 1.

Generally, when creating an activity, the database executes the function by hour until the status field value is set to 1 when the condition is met.

Thought or rough writing,