Spokesman says US president has 'been very clear' about willingness to revisit relations with Riyadh, amid fears that oil cartel's move could send prices soaring ahead of midterms