Hi Ayush,
I think Get Transaction Queue Activity gets the Queue with New status (default status after adding it to the queue). So when bot1 gets the 1st queue, your automation will update its status to In-Progress then the bot2 will skipped it and will check on the next Queue with New status.
You may check this thread: