根据同一行python sqlalchemy中的多个列值筛选和更新每行的特定列

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class MyTable(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    column1 = Column(String)
    column2 = Column(String)
    column3 = Column(String)

engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

session.query(MyTable).filter(MyTable.column1 == 'value1', MyTable.column2 == 'value2').update({MyTable.column3: 'new_value'})

session.commit()
session.close()