mysql

select * from information_schema.innodb_trx a where TIME_TO_SEC(timediff(now(),a.trx_started))>30;