findCancelledUnfinishedNormalTaskIdsForUpdate
@Query(value = "
select
t.id
from task t
join task_type tt on tt.id = t.type_id
where
t.is_cancelled = true and
t.running_status < 50 and
t.update_time <= :cancelledBefore and
tt.category = 10
order by
t.id
limit :limit
for update of t skip locked
", nativeQuery = true)