UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qdxJOqmKOjBt48CANpkqCym414PhbcpVRa4U5I+s8Sw='
WHERE
key_id = 'b23ec348b926264da5aebd4707d73988390bb15019f46f1f14f01d3bcaacc702'
AND (
token = 'qdxJOqmKOjBt48CANpkqCym414PhbcpVRa4U5I+s8Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)