drupal7 带表达式条件的update

set @price=91;

update drupal754.my_payment_card  set balance = balance - @price  where  card_no=1 and balance - @price>=0

$total_amount=1;
$rows= db_update(‘my_payment_card‘)
        ->expression(‘balance‘,  ‘balance - :price‘,array(‘price‘ => $total_amount))
        ->condition(‘card_no‘,1)
        ->where(‘balance - :price >= 0‘, array(‘price‘ =>$total_amount))
        ->execute();