I'd be interested in a proper discussion about one database transaction or two, including the small details people tend to leave out. What breaks if a payment is recorded but the order update fails? Developers, please describe the environment and the smallest example that shows the problem. What would you check first, and what result would change your next step? Keep passwords, tokens and other private values out of any code you share. What would you tell someone who was unsure where to start?