Reset stuck autorenewals

update action_trigger.event
set state = 'pending'
where id in (select event.id
from action_trigger.event
left join action.circulation
on circulation.parent_circ = event.target
where event_def = <autorenewal_event_id>
and add_time::date = now()::date
and state <> 'complete' and state <> 'error'
and state <> 'invalid'
and circulation is null);