Well, my problem seems a little confusing. I need to lock a table row while I am in a transaction, then I have to unlock it but I still want to be in transaction. Maybe it must be a nested transaction or sth ?

Code:
BEGIN;

LOCK_ROW;

UNLOCK_ROW;

COMMIT;
The main problem in here, when I want to unlock the row, I need to use COMMIT so my transaction ended before i preffered. I'm not sure if I make myself clear enough but still hoping to get some ideas...