I use sql query what affected 120 000 rows, and sometimes it work correct (3-5 seconds), but often it just stuck.
DB: Postgres. Try on docker image of postgres 16, on server DB. Try with query console, try from java code – result is same. Sometimes work, sometimes stuck.

update renamed_account.renamed_account set level=0, chain_id=gen_random_uuid() where old_number not in (select distinct new_number from renamed_account.renamed_account);