<update id="updateOrderFail">
update <include refid="table_name"></include> set
state = 2, update_time = NOW()
where state = 0 and NOW() > DATE_ADD(create_time, INTERVAL duration HOUR)
</update>
NOW() > DATE_ADD(create_time, INTERVAL duration HOUR)