客户选座业务需求，已知三个表，客户表，id和姓名，座位表，id和座位名称，状态，0空闲，1占用，客户占座表，id，客户id，座位id，选座时间，请写出占座api伪代码，参数为客户id，座位号id，不允许多个客户占用同一个座位，需要在多个并发请求下不出现问题且满足最大并发量

在设计这个API伪代码时，我们将考虑线程安全、并发控制和数据一致性。这里是一个基于乐观锁（假设数据库支持行级锁定）的伪代码示例：

import threading
from datetime import datetime

def check_seat_availability(customer_id, seat_id):
    with db_connection.cursor() as cursor:
        # 查询当前座位的状态及上次修改时间
        cursor.execute("""
            SELECT status, last_updated
            FROM seats
            WHERE id = %s FOR UPDATE;
        """, (seat_id,))
        row = cursor.fetchone()
        
        if not row or row[0] != 0:  # 座位已被占用或不存在
            return False, "该座位已占用"

        lock_version = row[1]

    def update_seat_status(lock_version):
        try:
            with db_connection.cursor() as cursor:
                # 使用行级锁更新状态并检查版本是否一致
                cursor.execute("""
                    UPDATE seats
                    SET status = 1, occupied_by = %s, occupied_at = %s
                    WHERE id = %s AND version = %s
                    RETURNING version;  # 获取新的版本号
                """, (customer_id, datetime.now(), seat_id, lock_version))
                
                updated_row = cursor.fetchone()
                if not updated_row or updated_row[0] != lock_version + 1:
                    raise Exception("锁冲突，座位状态已被其他操作改变")

                # 提交事务
                db_connection.commit()

                return True
        except Exception as e:
            print(f"Lock conflict: {str(e)}")
            return False

    # 尝试获取锁并更新状态
    success = update_seat_status(lock_version)

    if success:
        return True, f"座位{seat_id}已成功锁定"
    else:
        return False, "无法获取锁，座位可能被其他用户同时占用"

def reserve_seat(api_key, customer_id, seat_id):
    # 校验API密钥
    if not validate_api_key(api_key):
        return {"error": "无效API key"}

    # 单元锁并发控制
    with concurrent.futures.ThreadPoolExecutor(max_workers=10) as executor:
        future = executor.submit(check_seat_availability, customer_id, seat_id)
        result = future.result()

    if result[0]:
        return {"success": True, "message": result[1]}
    else:
        return {"success": False, "message": result[1]}

#