If MySQL minus transactions is what's in production, an easy way around the lack of transactions would be to make a temp table to process that data in. If it works, lock them both and update.

-Lee

"To be civilized is to deny one's nature."