mysql更新30分钟内的状态数据

UPDATE o_account_recharge_order SET order_state = 4  where now() > SUBDATE(create_time,interval -30 minute) and order_state = 1