American Express reported record revenue for the second quarter as its typically affluent cardmembers boosted spending by 7% from a year earlier, even as consumers grapple with lingering price inflation and uncertainty about the economy’s direction.