mydb = mysql.connector.connect(
    host="localhost",
    user="root",
    password="xxxx",
    database="xxxx",
    autocommit = True
    )

mycursor = mydb.cursor()
x = dict["MST"]["p"]

 mycursor.execute("""
    UPDATE
        currency_price_fact
    SET
        hour_1_price = %s
    WHERE
        currency_symbol = 'TPL'
                     """,(x,))