mysql 行锁操作值

update sup_payment_setting
           set paid_amount = paid_amount + #{amount}
        where id = #{id} and status = 1 and is_deleted = 0
          and sum_amount >= paid_amount + #{amount}