Unlock lock in a db table
There is no way for non-dba sessions to kill other sessions, or interfere with their locks in any way. Think about it. That would be a security disaster.

You need to issue your commit or rollback in the same session that launched the query. If you lose the session, you must ask your DBA to kill it for you.