A British man who had spent 16 years on death row has been executed after the US Supreme Court rejected a last-minute appeal to spare his life.