MySQL event automatic kill runtime time-out SQL

Delimiter $
Create Event My_long_running_trx_monitor
On schedule every 1 minute
Starts ' 2015-09-15 11:00:00 '
On completion preserve enable do
Begin
DECLARE v_sql varchar (500);
Declare No_more_long_running_trx integer default 0;
DECLARE C_tid cursor FOR
Select Concat (' Kill ', trx_mysql_thread_id, '; ')
From Information_schema.innodb_trx
where Timestampdiff (Minute,trx_started,now ()) >= 1;
Declare continue handler for not found
Set no_more_long_running_trx=1;

Open C_tid;
Repeat
Fetch C_tid into V_sql;
Set @v_sql =v_sql;
Prepare stmt from @v_sql;
Execute stmt;
deallocate prepare stmt;
Until No_more_long_running_trx end repeat;
Close C_tid;
End
$
delimiter;

MySQL event automatic kill runtime time-out SQL