Consider adding index on transactions(status, id, amount) to reduce SELECTion time required.
This should minimize COMPLETE ROW READS.