[Answer]-Data inserted in atomic transaction persists even after rollback

Ohk, I checked out mysql docs. Looks like unlocking tables implicitly causes a commit if there are any locked tables, which there are in my case. Will have to find a workaround.