pg_try_advisory_lock and other advisory lock functions take a lock on a key. The keys you have tried to lock are 0 and 1. Why?
What problem are you trying to solve by changing from "for update" lock to advisory lock anyway?
What problem are you trying to solve by changing from "for update" lock to advisory lock anyway?